Overview

Dataset statistics

Number of variables35
Number of observations164386
Missing cells1373638
Missing cells (%)23.9%
Duplicate rows22193
Duplicate rows (%)13.5%
Total size in memory45.1 MiB
Average record size in memory288.0 B

Variable types

NUM25
CAT7
BOOL2
DATE1

Reproduction

Analysis started2020-10-05 20:23:12.708192
Analysis finished2020-10-05 20:29:19.201270
Duration6 minutes and 6.49 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Dataset has 22193 (13.5%) duplicate rows Duplicates
pressure3pm is highly correlated with pressure9amHigh correlation
pressure9am is highly correlated with pressure3pmHigh correlation
temp9am is highly correlated with mintempHigh correlation
mintemp is highly correlated with temp9amHigh correlation
temp3pm is highly correlated with maxtempHigh correlation
maxtemp is highly correlated with temp3pmHigh correlation
humidity is highly correlated with humidity3pmHigh correlation
humidity3pm is highly correlated with humidityHigh correlation
evaporation has 74258 (45.2%) missing values Missing
sunshine has 83779 (51.0%) missing values Missing
humidity9am has 2034 (1.2%) missing values Missing
humidity3pm has 5124 (3.1%) missing values Missing
pressure9am has 16301 (9.9%) missing values Missing
pressure3pm has 16273 (9.9%) missing values Missing
cloud9am has 63507 (38.6%) missing values Missing
cloud3pm has 68670 (41.8%) missing values Missing
temp3pm has 4077 (2.5%) missing values Missing
humidity has 5124 (3.1%) missing values Missing
wind_gustdir has 127967 (77.8%) missing values Missing
wind_gustspeed has 127960 (77.8%) missing values Missing
wind_dir9am has 127454 (77.5%) missing values Missing
wind_dir3pm has 125396 (76.3%) missing values Missing
wind_speed9am has 125086 (76.1%) missing values Missing
wind_speed3pm has 125058 (76.1%) missing values Missing
windgustdir has 46997 (28.6%) missing values Missing
windgustspeed has 46944 (28.6%) missing values Missing
winddir9am has 48360 (29.4%) missing values Missing
winddir3pm has 43825 (26.7%) missing values Missing
windspeed9am has 40753 (24.8%) missing values Missing
windspeed3pm has 42911 (26.1%) missing values Missing
rainfall has 104117 (63.3%) zeros Zeros
sunshine has 2553 (1.6%) zeros Zeros
cloud9am has 9450 (5.7%) zeros Zeros
cloud3pm has 5298 (3.2%) zeros Zeros
amountOfRain has 105038 (63.9%) zeros Zeros
wind_speed9am has 2351 (1.4%) zeros Zeros
windspeed9am has 7570 (4.6%) zeros Zeros

Variables

date
Date

Distinct count3436
Unique (%)2.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
Minimum2007-01-01 00:11:00
Maximum2017-01-31 00:05:00
Histogram

location
Categorical

Distinct count49
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
Canberra
 
3877
Sydney
 
3798
Perth
 
3655
Darwin
 
3653
Hobart
 
3650
Other values (44)
145753
ValueCountFrequency (%) 
Canberra38772.4%
 
Sydney37982.3%
 
Perth36552.2%
 
Darwin36532.2%
 
Hobart36502.2%
 
Brisbane36182.2%
 
Adelaide35492.2%
 
Bendigo34912.1%
 
Townsville34892.1%
 
Ballarat34892.1%
 
Other values (39)12811777.9%
 

Length

Max length16
Median length8
Mean length8.695095689
Min length4

mintemp
Real number (ℝ)

HIGH CORRELATION

Distinct count389
Unique (%)0.2%
Missing772
Missing (%)0.5%
Infinite0
Infinite (%)0.0%
Mean12.166113535516523
Minimum-8.5
Maximum33.9
Zeros177
Zeros (%)0.1%
Memory size1.3 MiB

Quantile statistics

Minimum-8.5
5-th percentile1.8
Q17.6
median11.9
Q316.8
95-th percentile23.1
Maximum33.9
Range42.4
Interquartile range (IQR)9.2

Descriptive statistics

Standard deviation6.40119073
Coefficient of variation (CV)0.5261491857
Kurtosis-0.4830438876
Mean12.16611354
Median Absolute Deviation (MAD)4.6
Skewness0.04032331322
Sum1990546.5
Variance40.97524276
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9.610350.6%
 
10.210280.6%
 
1110240.6%
 
10.510130.6%
 
1010110.6%
 
910100.6%
 
8.99930.6%
 
129920.6%
 
10.89900.6%
 
10.49870.6%
 
Other values (379)15353193.4%
 
ValueCountFrequency (%) 
-8.51< 0.1%
 
-8.22< 0.1%
 
-82< 0.1%
 
-7.82< 0.1%
 
-7.62< 0.1%
 
ValueCountFrequency (%) 
33.91< 0.1%
 
31.91< 0.1%
 
31.81< 0.1%
 
31.44< 0.1%
 
31.21< 0.1%
 

maxtemp
Real number (ℝ)

HIGH CORRELATION

Distinct count505
Unique (%)0.3%
Missing397
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean23.19011092207404
Minimum-4.8
Maximum48.1
Zeros15
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum-4.8
5-th percentile12.8
Q117.9
median22.6
Q328.2
95-th percentile35.5
Maximum48.1
Range52.9
Interquartile range (IQR)10.3

Descriptive statistics

Standard deviation7.12029885
Coefficient of variation (CV)0.3070403101
Kurtosis-0.2356615366
Mean23.19011092
Median Absolute Deviation (MAD)5.1
Skewness0.2333731942
Sum3802923.1
Variance50.69865571
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2010160.6%
 
199600.6%
 
19.89500.6%
 
20.49430.6%
 
20.89330.6%
 
219290.6%
 
19.59230.6%
 
18.99220.6%
 
19.49190.6%
 
20.29140.6%
 
Other values (495)15458094.0%
 
ValueCountFrequency (%) 
-4.82< 0.1%
 
-4.11< 0.1%
 
-3.81< 0.1%
 
-3.71< 0.1%
 
-3.21< 0.1%
 
ValueCountFrequency (%) 
48.11< 0.1%
 
47.33< 0.1%
 
472< 0.1%
 
46.92< 0.1%
 
46.84< 0.1%
 

rainfall
Real number (ℝ≥0)

ZEROS

Distinct count679
Unique (%)0.4%
Missing1619
Missing (%)1.0%
Infinite0
Infinite (%)0.0%
Mean2.3543218219909443
Minimum0.0
Maximum371.0
Zeros104117
Zeros (%)63.3%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.8
95-th percentile13
Maximum371
Range371
Interquartile range (IQR)0.8

Descriptive statistics

Standard deviation8.417734503
Coefficient of variation (CV)3.575439188
Kurtosis172.8685562
Mean2.354321822
Median Absolute Deviation (MAD)0
Skewness9.719707325
Sum383205.9
Variance70.85825416
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
010411763.3%
 
0.2101726.2%
 
0.443142.6%
 
0.629171.8%
 
0.823131.4%
 
120001.2%
 
1.217501.1%
 
1.415991.0%
 
1.613770.8%
 
1.812500.8%
 
Other values (669)3095818.8%
 
(Missing)16191.0%
 
ValueCountFrequency (%) 
010411763.3%
 
0.11970.1%
 
0.2101726.2%
 
0.3840.1%
 
0.443142.6%
 
ValueCountFrequency (%) 
3711< 0.1%
 
367.61< 0.1%
 
278.41< 0.1%
 
268.61< 0.1%
 
247.21< 0.1%
 

evaporation
Real number (ℝ≥0)

MISSING

Distinct count356
Unique (%)0.4%
Missing74258
Missing (%)45.2%
Infinite0
Infinite (%)0.0%
Mean5.49461876442393
Minimum0.0
Maximum145.0
Zeros266
Zeros (%)0.2%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12.6
median4.8
Q37.4
95-th percentile12
Maximum145
Range145
Interquartile range (IQR)4.8

Descriptive statistics

Standard deviation4.275539083
Coefficient of variation (CV)0.7781320718
Kurtosis55.45145963
Mean5.494618764
Median Absolute Deviation (MAD)2.4
Skewness4.122042565
Sum495219
Variance18.28023445
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
437442.3%
 
829561.8%
 
2.222751.4%
 
222331.4%
 
2.421771.3%
 
2.621701.3%
 
321601.3%
 
3.421501.3%
 
1.821461.3%
 
3.221101.3%
 
Other values (346)6600740.2%
 
(Missing)7425845.2%
 
ValueCountFrequency (%) 
02660.2%
 
0.113< 0.1%
 
0.25270.3%
 
0.316< 0.1%
 
0.48200.5%
 
ValueCountFrequency (%) 
1452< 0.1%
 
86.22< 0.1%
 
82.41< 0.1%
 
81.21< 0.1%
 
77.31< 0.1%
 

sunshine
Real number (ℝ≥0)

MISSING
ZEROS

Distinct count145
Unique (%)0.2%
Missing83779
Missing (%)51.0%
Infinite0
Infinite (%)0.0%
Mean7.607071346161004
Minimum0.0
Maximum14.5
Zeros2553
Zeros (%)1.6%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0.3
Q14.9
median8.4
Q310.6
95-th percentile12.8
Maximum14.5
Range14.5
Interquartile range (IQR)5.7

Descriptive statistics

Standard deviation3.778323829
Coefficient of variation (CV)0.4966857358
Kurtosis-0.8196559822
Mean7.607071346
Median Absolute Deviation (MAD)2.6
Skewness-0.5002194816
Sum613183.2
Variance14.27573095
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
025531.6%
 
10.711600.7%
 
1111530.7%
 
10.811380.7%
 
10.511090.7%
 
10.910990.7%
 
10.310770.7%
 
10.210590.6%
 
1010570.6%
 
11.110430.6%
 
Other values (135)6815941.5%
 
(Missing)8377951.0%
 
ValueCountFrequency (%) 
025531.6%
 
0.15730.3%
 
0.25700.3%
 
0.34530.3%
 
0.43470.2%
 
ValueCountFrequency (%) 
14.51< 0.1%
 
14.34< 0.1%
 
14.22< 0.1%
 
14.17< 0.1%
 
1416< 0.1%
 

humidity9am
Real number (ℝ≥0)

MISSING

Distinct count101
Unique (%)0.1%
Missing2034
Missing (%)1.2%
Infinite0
Infinite (%)0.0%
Mean69.08449541736474
Minimum0.0
Maximum100.0
Zeros1
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile34
Q157
median70
Q383
95-th percentile98
Maximum100
Range100
Interquartile range (IQR)26

Descriptive statistics

Standard deviation18.99304951
Coefficient of variation (CV)0.2749249219
Kurtosis-0.05275203679
Mean69.08449542
Median Absolute Deviation (MAD)13
Skewness-0.4796766061
Sum11216006
Variance360.7359295
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9938152.3%
 
7034812.1%
 
10034642.1%
 
6534162.1%
 
6834132.1%
 
6934082.1%
 
7133782.1%
 
6633712.1%
 
7233322.0%
 
6733262.0%
 
Other values (91)12794877.8%
 
ValueCountFrequency (%) 
01< 0.1%
 
15< 0.1%
 
28< 0.1%
 
310< 0.1%
 
422< 0.1%
 
ValueCountFrequency (%) 
10034642.1%
 
9938152.3%
 
9825111.5%
 
9721181.3%
 
9618621.1%
 

humidity3pm
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count101
Unique (%)0.1%
Missing5124
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean51.66956336100262
Minimum0.0
Maximum100.0
Zeros4
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile17
Q137
median52
Q366
95-th percentile88
Maximum100
Range100
Interquartile range (IQR)29

Descriptive statistics

Standard deviation20.7609592
Coefficient of variation (CV)0.4018024897
Kurtosis-0.5074502112
Mean51.66956336
Median Absolute Deviation (MAD)14
Skewness0.03766029493
Sum8228998
Variance431.017427
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5731301.9%
 
5231221.9%
 
5530941.9%
 
5930311.8%
 
5330311.8%
 
5630091.8%
 
5830061.8%
 
5029731.8%
 
6029691.8%
 
5429631.8%
 
Other values (91)12893478.4%
 
(Missing)51243.1%
 
ValueCountFrequency (%) 
04< 0.1%
 
126< 0.1%
 
235< 0.1%
 
365< 0.1%
 
41180.1%
 
ValueCountFrequency (%) 
1005370.3%
 
994920.3%
 
986880.4%
 
974610.3%
 
965340.3%
 

pressure9am
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count546
Unique (%)0.4%
Missing16301
Missing (%)9.9%
Infinite0
Infinite (%)0.0%
Mean1017.6454556504711
Minimum980.5
Maximum1041.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum980.5
5-th percentile1006.1
Q11012.9
median1017.6
Q31022.4
95-th percentile1029.5
Maximum1041
Range60.5
Interquartile range (IQR)9.5

Descriptive statistics

Standard deviation7.129290981
Coefficient of variation (CV)0.007005672694
Kurtosis0.2693896181
Mean1017.645456
Median Absolute Deviation (MAD)4.7
Skewness-0.1128570668
Sum150698027.3
Variance50.82678989
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1016.49240.6%
 
1017.99080.6%
 
1017.38860.5%
 
10188830.5%
 
1018.78810.5%
 
1015.98710.5%
 
1015.58660.5%
 
1016.38660.5%
 
1017.88640.5%
 
1015.78620.5%
 
Other values (536)13927484.7%
 
(Missing)163019.9%
 
ValueCountFrequency (%) 
980.51< 0.1%
 
9822< 0.1%
 
982.22< 0.1%
 
982.32< 0.1%
 
982.93< 0.1%
 
ValueCountFrequency (%) 
10411< 0.1%
 
1040.91< 0.1%
 
1040.62< 0.1%
 
1040.51< 0.1%
 
1040.43< 0.1%
 

pressure3pm
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count549
Unique (%)0.4%
Missing16273
Missing (%)9.9%
Infinite0
Infinite (%)0.0%
Mean1015.2453025190225
Minimum977.1
Maximum1039.6
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum977.1
5-th percentile1004
Q11010.4
median1015.2
Q31020
95-th percentile1026.9
Maximum1039.6
Range62.5
Interquartile range (IQR)9.6

Descriptive statistics

Standard deviation7.05609818
Coefficient of variation (CV)0.006950141175
Kurtosis0.1551495431
Mean1015.245303
Median Absolute Deviation (MAD)4.8
Skewness-0.05901271552
Sum150371027.5
Variance49.78852152
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1015.58980.5%
 
1015.38820.5%
 
1015.78740.5%
 
1015.18710.5%
 
1015.68700.5%
 
1015.48670.5%
 
1015.88670.5%
 
10168600.5%
 
1013.58520.5%
 
1015.28460.5%
 
Other values (539)13942684.8%
 
(Missing)162739.9%
 
ValueCountFrequency (%) 
977.12< 0.1%
 
978.22< 0.1%
 
9791< 0.1%
 
980.22< 0.1%
 
981.21< 0.1%
 
ValueCountFrequency (%) 
1039.61< 0.1%
 
1038.91< 0.1%
 
1038.51< 0.1%
 
1038.41< 0.1%
 
1038.21< 0.1%
 

cloud9am
Real number (ℝ≥0)

MISSING
ZEROS

Distinct count10
Unique (%)< 0.1%
Missing63507
Missing (%)38.6%
Infinite0
Infinite (%)0.0%
Mean4.505328165425906
Minimum0.0
Maximum9.0
Zeros9450
Zeros (%)5.7%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median5
Q37
95-th percentile8
Maximum9
Range9
Interquartile range (IQR)6

Descriptive statistics

Standard deviation2.893437895
Coefficient of variation (CV)0.6422257799
Kurtosis-1.529387348
Mean4.505328165
Median Absolute Deviation (MAD)3
Skewness-0.2526857912
Sum454493
Variance8.371982852
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
72225613.5%
 
81774310.8%
 
11741910.6%
 
094505.7%
 
690865.5%
 
272544.4%
 
365584.0%
 
561783.8%
 
449333.0%
 
92< 0.1%
 
(Missing)6350738.6%
 
ValueCountFrequency (%) 
094505.7%
 
11741910.6%
 
272544.4%
 
365584.0%
 
449333.0%
 
ValueCountFrequency (%) 
92< 0.1%
 
81774310.8%
 
72225613.5%
 
690865.5%
 
561783.8%
 

cloud3pm
Real number (ℝ≥0)

MISSING
ZEROS

Distinct count10
Unique (%)< 0.1%
Missing68670
Missing (%)41.8%
Infinite0
Infinite (%)0.0%
Mean4.560992937439926
Minimum0.0
Maximum9.0
Zeros5298
Zeros (%)3.2%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q12
median5
Q37
95-th percentile8
Maximum9
Range9
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.731072494
Coefficient of variation (CV)0.5987890206
Kurtosis-1.455244411
Mean4.560992937
Median Absolute Deviation (MAD)2
Skewness-0.2425796017
Sum436560
Variance7.458756968
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
72008812.2%
 
11653810.1%
 
8152339.3%
 
697265.9%
 
280054.9%
 
375504.6%
 
574094.5%
 
458683.6%
 
052983.2%
 
91< 0.1%
 
(Missing)6867041.8%
 
ValueCountFrequency (%) 
052983.2%
 
11653810.1%
 
280054.9%
 
375504.6%
 
458683.6%
 
ValueCountFrequency (%) 
91< 0.1%
 
8152339.3%
 
72008812.2%
 
697265.9%
 
574094.5%
 

temp9am
Real number (ℝ)

HIGH CORRELATION

Distinct count440
Unique (%)0.3%
Missing976
Missing (%)0.6%
Infinite0
Infinite (%)0.0%
Mean16.949419864145405
Minimum-7.2
Maximum40.2
Zeros38
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum-7.2
5-th percentile6.9
Q112.2
median16.6
Q321.5
95-th percentile28.2
Maximum40.2
Range47.4
Interquartile range (IQR)9.3

Descriptive statistics

Standard deviation6.494966589
Coefficient of variation (CV)0.383196985
Kurtosis-0.3447351777
Mean16.94941986
Median Absolute Deviation (MAD)4.6
Skewness0.1036326171
Sum2769704.7
Variance42.184591
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
13.810420.6%
 
14.810180.6%
 
1610160.6%
 
1710130.6%
 
149950.6%
 
159920.6%
 
16.69850.6%
 
15.49740.6%
 
16.59720.6%
 
15.19690.6%
 
Other values (430)15343493.3%
 
(Missing)9760.6%
 
ValueCountFrequency (%) 
-7.22< 0.1%
 
-72< 0.1%
 
-6.21< 0.1%
 
-5.91< 0.1%
 
-5.63< 0.1%
 
ValueCountFrequency (%) 
40.21< 0.1%
 
39.41< 0.1%
 
39.11< 0.1%
 
391< 0.1%
 
38.91< 0.1%
 

temp3pm
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct count500
Unique (%)0.3%
Missing4077
Missing (%)2.5%
Infinite0
Infinite (%)0.0%
Mean21.63317218621537
Minimum-5.4
Maximum46.7
Zeros17
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum-5.4
5-th percentile11.5
Q116.6
median21.1
Q326.4
95-th percentile33.6
Maximum46.7
Range52.1
Interquartile range (IQR)9.8

Descriptive statistics

Standard deviation6.932849064
Coefficient of variation (CV)0.3204730681
Kurtosis-0.1349960626
Mean21.63317219
Median Absolute Deviation (MAD)4.8
Skewness0.2427139888
Sum3467992.2
Variance48.06439614
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
209830.6%
 
18.49830.6%
 
18.59820.6%
 
199680.6%
 
17.89670.6%
 
19.39510.6%
 
189430.6%
 
18.69350.6%
 
179340.6%
 
19.49320.6%
 
Other values (490)15073191.7%
 
(Missing)40772.5%
 
ValueCountFrequency (%) 
-5.42< 0.1%
 
-5.11< 0.1%
 
-4.41< 0.1%
 
-4.22< 0.1%
 
-4.11< 0.1%
 
ValueCountFrequency (%) 
46.72< 0.1%
 
46.22< 0.1%
 
46.13< 0.1%
 
45.91< 0.1%
 
45.82< 0.1%
 

raintoday
Boolean

Distinct count2
Unique (%)< 0.1%
Missing1619
Missing (%)1.0%
Memory size1.3 MiB
No
126200
Yes
36567
(Missing)
 
1619
ValueCountFrequency (%) 
No12620076.8%
 
Yes3656722.2%
 
(Missing)16191.0%
 

amountOfRain
Real number (ℝ≥0)

ZEROS

Distinct count681
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3632596449819325
Minimum0.0
Maximum371.0
Zeros105038
Zeros (%)63.9%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.8
95-th percentile13
Maximum371
Range371
Interquartile range (IQR)0.8

Descriptive statistics

Standard deviation8.419366365
Coefficient of variation (CV)3.562607428
Kurtosis171.28584
Mean2.363259645
Median Absolute Deviation (MAD)0
Skewness9.66526212
Sum388486.8
Variance70.88572998
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
010503863.9%
 
0.2102636.2%
 
0.443502.6%
 
0.629551.8%
 
0.823451.4%
 
120161.2%
 
1.217711.1%
 
1.416151.0%
 
1.613930.8%
 
1.812660.8%
 
Other values (671)3137419.1%
 
ValueCountFrequency (%) 
010503863.9%
 
0.12000.1%
 
0.2102636.2%
 
0.3850.1%
 
0.443502.6%
 
ValueCountFrequency (%) 
3711< 0.1%
 
367.61< 0.1%
 
278.41< 0.1%
 
268.61< 0.1%
 
247.21< 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
No
127338
Yes
37048
ValueCountFrequency (%) 
No12733877.5%
 
Yes3704822.5%
 

temp
Real number (ℝ)

Distinct count7620
Unique (%)4.6%
Missing397
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean28.470265632407173
Minimum-3.76
Maximum59.72
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum-3.76
5-th percentile3.473824179
Q122.52
median28.52
Q335.36
95-th percentile44.36
Maximum59.72
Range63.48
Interquartile range (IQR)12.84

Descriptive statistics

Standard deviation10.22528483
Coefficient of variation (CV)0.359156636
Kurtosis0.4721549931
Mean28.47026563
Median Absolute Deviation (MAD)6.36
Skewness-0.4141530851
Sum4668810.391
Variance104.5564499
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
269720.6%
 
24.89160.6%
 
25.769140.6%
 
26.488840.5%
 
24.688830.5%
 
27.28790.5%
 
26.968780.5%
 
25.48730.5%
 
25.888720.5%
 
25.288710.5%
 
Other values (7610)15504794.3%
 
ValueCountFrequency (%) 
-3.762< 0.1%
 
-2.921< 0.1%
 
-2.561< 0.1%
 
-1.841< 0.1%
 
-1.722< 0.1%
 
ValueCountFrequency (%) 
59.721< 0.1%
 
58.763< 0.1%
 
58.42< 0.1%
 
58.282< 0.1%
 
58.164< 0.1%
 

humidity
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count4163
Unique (%)2.6%
Missing5124
Missing (%)3.1%
Infinite0
Infinite (%)0.0%
Mean62.21218436422996
Minimum2.0
Maximum122.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum2
5-th percentile16.4
Q144
median63.2
Q380
95-th percentile106.4
Maximum122
Range120
Interquartile range (IQR)36

Descriptive statistics

Standard deviation26.62052964
Coefficient of variation (CV)0.4278989705
Kurtosis-0.3860322964
Mean62.21218436
Median Absolute Deviation (MAD)18
Skewness-0.1243788503
Sum9908036.906
Variance708.6525983
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
70.430421.9%
 
64.430301.8%
 
6830111.8%
 
65.629391.8%
 
72.829351.8%
 
71.629181.8%
 
69.229091.8%
 
7428801.8%
 
66.828691.7%
 
6228691.7%
 
Other values (4153)12986079.0%
 
(Missing)51243.1%
 
ValueCountFrequency (%) 
24< 0.1%
 
2.000285661< 0.1%
 
2.0005134141< 0.1%
 
2.0010653111< 0.1%
 
2.0011859811< 0.1%
 
ValueCountFrequency (%) 
1225240.3%
 
120.84780.3%
 
119.66640.4%
 
118.44520.3%
 
117.25110.3%
 

precipitation3pm
Real number (ℝ≥0)

Distinct count27
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10.014611949922744
Minimum0
Maximum26
Zeros17
Zeros (%)< 0.1%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile5
Q18
median10
Q312
95-th percentile15
Maximum26
Range26
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.174690898
Coefficient of variation (CV)0.3170058824
Kurtosis0.1043920325
Mean10.01461195
Median Absolute Deviation (MAD)2
Skewness0.3205194297
Sum1646262
Variance10.0786623
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
92046712.5%
 
102030912.4%
 
111873611.4%
 
81849511.3%
 
12155939.5%
 
7148509.0%
 
13120337.3%
 
6104316.3%
 
1485845.2%
 
561073.7%
 
Other values (17)1878111.4%
 
ValueCountFrequency (%) 
017< 0.1%
 
169< 0.1%
 
23700.2%
 
312710.8%
 
430731.9%
 
ValueCountFrequency (%) 
264< 0.1%
 
255< 0.1%
 
248< 0.1%
 
2337< 0.1%
 
2273< 0.1%
 

precipitation9am
Real number (ℝ)

Distinct count142193
Unique (%)86.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.995437942353472
Minimum-17.7393457403299
Maximum32.4785898089529
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum-17.73934574
5-th percentile1.763924092
Q16.64601366
median9.996363073
Q313.37960089
95-th percentile18.22206579
Maximum32.47858981
Range50.21793555
Interquartile range (IQR)6.733587232

Descriptive statistics

Standard deviation4.998239211
Coefficient of variation (CV)0.5000520477
Kurtosis0.003843435433
Mean9.995437942
Median Absolute Deviation (MAD)3.367733616
Skewness-0.006724031779
Sum1643110.062
Variance24.98239521
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
6.3107977842< 0.1%
 
10.049176492< 0.1%
 
15.415726822< 0.1%
 
8.7881873712< 0.1%
 
8.4397343892< 0.1%
 
14.324567882< 0.1%
 
15.115114152< 0.1%
 
16.910888952< 0.1%
 
11.912473092< 0.1%
 
1.0366280092< 0.1%
 
Other values (142183)164366> 99.9%
 
ValueCountFrequency (%) 
-17.739345741< 0.1%
 
-11.035403711< 0.1%
 
-11.023931311< 0.1%
 
-10.698081062< 0.1%
 
-10.302856511< 0.1%
 
ValueCountFrequency (%) 
32.478589811< 0.1%
 
32.21008071< 0.1%
 
30.355796971< 0.1%
 
30.243844882< 0.1%
 
30.174273091< 0.1%
 

modelo_vigente
Real number (ℝ≥0)

Distinct count130381
Unique (%)79.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.2302066959205493
Minimum0.0
Maximum0.9994
Zeros471
Zeros (%)0.3%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0.004595059479
Q10.03225130191
median0.1083058078
Q30.3374927775
95-th percentile0.8478924242
Maximum0.9994
Range0.9994
Interquartile range (IQR)0.3052414756

Descriptive statistics

Standard deviation0.2691578395
Coefficient of variation (CV)1.169200741
Kurtosis0.5749034484
Mean0.2302066959
Median Absolute Deviation (MAD)0.09300930289
Skewness1.326379389
Sum37842.75792
Variance0.07244594256
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04710.3%
 
0.001940.1%
 
0.000666666666773< 0.1%
 
0.000469< 0.1%
 
0.000567< 0.1%
 
0.00263< 0.1%
 
0.000260< 0.1%
 
0.000222222222259< 0.1%
 
0.000333333333357< 0.1%
 
0.0002550< 0.1%
 
Other values (130371)16332399.4%
 
ValueCountFrequency (%) 
04710.3%
 
6.600660066e-063< 0.1%
 
7.989347537e-0636< 0.1%
 
1.075268817e-051< 0.1%
 
1.578947368e-051< 0.1%
 
ValueCountFrequency (%) 
0.99941< 0.1%
 
0.99926984131< 0.1%
 
0.99913095241< 0.1%
 
0.99833333331< 0.1%
 
0.99807301591< 0.1%
 

wind_gustdir
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing127967
Missing (%)77.8%
Memory size1.3 MiB
SE
 
2625
SW
 
2542
W
 
2529
S
 
2522
N
 
2470
Other values (11)
23731
ValueCountFrequency (%) 
SE26251.6%
 
SW25421.5%
 
W25291.5%
 
S25221.5%
 
N24701.5%
 
SSE24461.5%
 
WSW24341.5%
 
E24241.5%
 
SSW22981.4%
 
WNW21961.3%
 
Other values (6)119337.3%
 
(Missing)12796777.8%
 

Length

Max length3
Median length3
Mean length2.822563965
Min length1

wind_gustspeed
Real number (ℝ≥0)

MISSING

Distinct count63
Unique (%)0.2%
Missing127960
Missing (%)77.8%
Infinite0
Infinite (%)0.0%
Mean40.38744303519464
Minimum7.0
Maximum135.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum7
5-th percentile22
Q131
median39
Q348
95-th percentile65
Maximum135
Range128
Interquartile range (IQR)17

Descriptive statistics

Standard deviation13.53278336
Coefficient of variation (CV)0.3350740316
Kurtosis1.625654633
Mean40.38744304
Median Absolute Deviation (MAD)8
Skewness0.9130138439
Sum1471153
Variance183.1362256
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3524981.5%
 
3924481.5%
 
3122791.4%
 
3321801.3%
 
3721431.3%
 
4120901.3%
 
3018551.1%
 
4318291.1%
 
2816871.0%
 
4415340.9%
 
Other values (53)158839.7%
 
(Missing)12796077.8%
 
ValueCountFrequency (%) 
74< 0.1%
 
914< 0.1%
 
1127< 0.1%
 
131260.1%
 
151900.1%
 
ValueCountFrequency (%) 
1352< 0.1%
 
1262< 0.1%
 
1241< 0.1%
 
1201< 0.1%
 
1171< 0.1%
 

wind_dir9am
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing127454
Missing (%)77.5%
Memory size1.3 MiB
N
 
3113
SE
 
2663
E
 
2633
SSE
 
2538
W
 
2367
Other values (11)
23618
ValueCountFrequency (%) 
N31131.9%
 
SE26631.6%
 
E26331.6%
 
SSE25381.5%
 
W23671.4%
 
S23501.4%
 
NW22821.4%
 
ENE22801.4%
 
SW22651.4%
 
NNE21971.3%
 
Other values (6)122447.4%
 
(Missing)12745477.5%
 

Length

Max length3
Median length3
Mean length2.815720317
Min length1

wind_dir3pm
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing125396
Missing (%)76.3%
Memory size1.3 MiB
SE
 
3244
S
 
2706
W
 
2656
SW
 
2643
WSW
 
2637
Other values (11)
25104
ValueCountFrequency (%) 
SE32442.0%
 
S27061.6%
 
W26561.6%
 
SW26431.6%
 
WSW26371.6%
 
SSE26111.6%
 
E24541.5%
 
WNW24171.5%
 
N24041.5%
 
ESE23541.4%
 
Other values (6)128647.8%
 
(Missing)12539676.3%
 

Length

Max length3
Median length3
Mean length2.811395131
Min length1

wind_speed9am
Real number (ℝ≥0)

MISSING
ZEROS

Distinct count39
Unique (%)0.1%
Missing125086
Missing (%)76.1%
Infinite0
Infinite (%)0.0%
Mean14.145648854961832
Minimum0.0
Maximum87.0
Zeros2351
Zeros (%)1.4%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q17
median13
Q319
95-th percentile30
Maximum87
Range87
Interquartile range (IQR)12

Descriptive statistics

Standard deviation8.928349253
Coefficient of variation (CV)0.6311728324
Kurtosis1.188131273
Mean14.14564885
Median Absolute Deviation (MAD)6
Skewness0.7820819194
Sum555924
Variance79.71542039
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
936932.2%
 
1335582.2%
 
1132452.0%
 
730071.8%
 
1529911.8%
 
1728851.8%
 
625301.5%
 
1924631.5%
 
023511.4%
 
2022031.3%
 
Other values (29)103746.3%
 
(Missing)12508676.1%
 
ValueCountFrequency (%) 
023511.4%
 
212130.7%
 
415811.0%
 
625301.5%
 
730071.8%
 
ValueCountFrequency (%) 
871< 0.1%
 
831< 0.1%
 
743< 0.1%
 
671< 0.1%
 
652< 0.1%
 

wind_speed3pm
Real number (ℝ≥0)

MISSING

Distinct count41
Unique (%)0.1%
Missing125058
Missing (%)76.1%
Infinite0
Infinite (%)0.0%
Mean18.948916802278276
Minimum0.0
Maximum87.0
Zeros318
Zeros (%)0.2%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile6
Q113
median19
Q324
95-th percentile35
Maximum87
Range87
Interquartile range (IQR)11

Descriptive statistics

Standard deviation8.774876547
Coefficient of variation (CV)0.4630806414
Kurtosis0.7977314
Mean18.9489168
Median Absolute Deviation (MAD)6
Skewness0.5884125002
Sum745223
Variance76.99845841
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1734372.1%
 
1333402.0%
 
2032912.0%
 
1531851.9%
 
1931741.9%
 
1126111.6%
 
2425631.6%
 
2225311.5%
 
925041.5%
 
2618961.2%
 
Other values (31)107966.6%
 
(Missing)12505876.1%
 
ValueCountFrequency (%) 
03180.2%
 
22710.2%
 
45580.3%
 
69750.6%
 
715610.9%
 
ValueCountFrequency (%) 
871< 0.1%
 
831< 0.1%
 
762< 0.1%
 
691< 0.1%
 
671< 0.1%
 

windgustdir
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing46997
Missing (%)28.6%
Memory size1.3 MiB
W
 
8922
N
 
8043
SE
 
8029
E
 
8022
WSW
 
7886
Other values (11)
76487
ValueCountFrequency (%) 
W89225.4%
 
N80434.9%
 
SE80294.9%
 
E80224.9%
 
WSW78864.8%
 
SSE77934.7%
 
SSW77804.7%
 
S76474.7%
 
SW76164.6%
 
NW72944.4%
 
Other values (6)3835723.3%
 
(Missing)4699728.6%
 

Length

Max length3
Median length3
Mean length2.425875683
Min length1

windgustspeed
Real number (ℝ≥0)

MISSING

Distinct count66
Unique (%)0.1%
Missing46944
Missing (%)28.6%
Infinite0
Infinite (%)0.0%
Mean39.701691047495785
Minimum6.0
Maximum135.0
Zeros0
Zeros (%)0.0%
Memory size1.3 MiB

Quantile statistics

Minimum6
5-th percentile20
Q130
median37
Q348
95-th percentile65
Maximum135
Range129
Interquartile range (IQR)18

Descriptive statistics

Standard deviation13.64432793
Coefficient of variation (CV)0.3436712031
Kurtosis1.316042277
Mean39.70169105
Median Absolute Deviation (MAD)7
Skewness0.8614914618
Sum4662646
Variance186.1676846
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3579674.8%
 
3974484.5%
 
3173854.5%
 
3770214.3%
 
3368544.2%
 
4162183.8%
 
3062053.8%
 
2857563.5%
 
4356243.4%
 
4646282.8%
 
Other values (56)5233631.8%
 
(Missing)4694428.6%
 
ValueCountFrequency (%) 
61< 0.1%
 
715< 0.1%
 
9950.1%
 
111970.1%
 
135120.3%
 
ValueCountFrequency (%) 
1351< 0.1%
 
1301< 0.1%
 
1241< 0.1%
 
1222< 0.1%
 
1202< 0.1%
 

winddir9am
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing48360
Missing (%)29.4%
Memory size1.3 MiB
N
 
10181
SE
 
7840
E
 
7764
NW
 
7757
SSE
 
7751
Other values (11)
74733
ValueCountFrequency (%) 
N101816.2%
 
SE78404.8%
 
E77644.7%
 
NW77574.7%
 
SSE77514.7%
 
S73134.4%
 
SW72974.4%
 
W72064.4%
 
NNE70814.3%
 
NNW70164.3%
 
Other values (6)3882023.6%
 
(Missing)4836029.4%
 

Length

Max length3
Median length3
Mean length2.426258927
Min length1

winddir3pm
Categorical

MISSING

Distinct count16
Unique (%)< 0.1%
Missing43825
Missing (%)26.7%
Memory size1.3 MiB
W
 
8867
SE
 
8775
S
 
8265
WSW
 
8092
SW
 
7987
Other values (11)
78575
ValueCountFrequency (%) 
W88675.4%
 
SE87755.3%
 
S82655.0%
 
WSW80924.9%
 
SW79874.9%
 
SSE78284.8%
 
N77004.7%
 
WNW76734.7%
 
NW75164.6%
 
ESE72694.4%
 
Other values (6)4058924.7%
 
(Missing)4382526.7%
 

Length

Max length3
Median length3
Mean length2.421629579
Min length1

windspeed9am
Real number (ℝ≥0)

MISSING
ZEROS

Distinct count42
Unique (%)< 0.1%
Missing40753
Missing (%)24.8%
Infinite0
Infinite (%)0.0%
Mean13.9012399602048
Minimum0.0
Maximum130.0
Zeros7570
Zeros (%)4.6%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile0
Q17
median13
Q319
95-th percentile30
Maximum130
Range130
Interquartile range (IQR)12

Descriptive statistics

Standard deviation8.848133877
Coefficient of variation (CV)0.6364996146
Kurtosis1.45263166
Mean13.90123996
Median Absolute Deviation (MAD)6
Skewness0.7919918891
Sum1718652
Variance78.28947311
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9120077.3%
 
13113616.9%
 
11101106.2%
 
1793915.7%
 
792625.6%
 
1590295.5%
 
679374.8%
 
075704.6%
 
1974204.5%
 
2069204.2%
 
Other values (32)3262619.8%
 
(Missing)4075324.8%
 
ValueCountFrequency (%) 
075704.6%
 
241082.5%
 
456653.4%
 
679374.8%
 
792625.6%
 
ValueCountFrequency (%) 
1302< 0.1%
 
871< 0.1%
 
742< 0.1%
 
721< 0.1%
 
692< 0.1%
 

windspeed3pm
Real number (ℝ≥0)

MISSING

Distinct count41
Unique (%)< 0.1%
Missing42911
Missing (%)26.1%
Infinite0
Infinite (%)0.0%
Mean18.4517061123688
Minimum0.0
Maximum83.0
Zeros882
Zeros (%)0.5%
Memory size1.3 MiB

Quantile statistics

Minimum0
5-th percentile6
Q113
median17
Q324
95-th percentile33
Maximum83
Range83
Interquartile range (IQR)11

Descriptive statistics

Standard deviation8.778299542
Coefficient of variation (CV)0.4757445999
Kurtosis0.7780722111
Mean18.45170611
Median Absolute Deviation (MAD)6
Skewness0.6609954925
Sum2241421
Variance77.05854285
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
13110396.7%
 
17107536.5%
 
20100096.1%
 
1599086.0%
 
1994945.8%
 
1188955.4%
 
986855.3%
 
2475414.6%
 
2270794.3%
 
2853913.3%
 
Other values (31)3268119.9%
 
(Missing)4291126.1%
 
ValueCountFrequency (%) 
08820.5%
 
28940.5%
 
419621.2%
 
634062.1%
 
752133.2%
 
ValueCountFrequency (%) 
831< 0.1%
 
781< 0.1%
 
741< 0.1%
 
722< 0.1%
 
692< 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

datelocationmintempmaxtemprainfallevaporationsunshinehumidity9amhumidity3pmpressure9ampressure3pmcloud9amcloud3pmtemp9amtemp3pmraintodayamountOfRainraintomorrowtemphumidityprecipitation3pmprecipitation9ammodelo_vigentewind_gustdirwind_gustspeedwind_dir9amwind_dir3pmwind_speed9amwind_speed3pmwindgustdirwindgustspeedwinddir9amwinddir3pmwindspeed9amwindspeed3pm
02008-01-01 00:12:00Albury13.422.90.6NaNNaN71.022.01007.71007.18.0NaN16.921.8No0.0No29.4828.400000125.1153600.089825W44.0WWNW20.024.0NaNNaNNaNNaNNaNNaN
12008-01-02 00:12:00Albury7.425.10.0NaNNaN44.025.01010.61007.8NaNNaN17.224.3No0.0No32.122.2085691021.4971000.023477WNW44.0NNWWSW4.022.0NaNNaNNaNNaNNaNNaN
22008-01-03 00:12:00Albury12.925.70.0NaNNaN38.030.01007.61008.7NaN2.021.023.2No0.0No32.8438.0000001720.7828590.027580WSW46.0WWSW19.026.0NaNNaNNaNNaNNaNNaN
32008-01-04 00:12:00Albury9.228.00.0NaNNaN45.016.01017.61012.8NaNNaN18.126.5No1.0No35.6021.200000812.0286460.023962NE24.0SEE11.09.0NaNNaNNaNNaNNaNNaN
42008-01-05 00:12:00Albury17.532.31.0NaNNaN82.033.01010.81006.07.08.017.829.7No0.2No40.7641.600000911.8835460.220164W41.0ENENW7.020.0NaNNaNNaNNaNNaNNaN
52008-01-06 00:12:00Albury14.629.70.2NaNNaN55.023.01009.21005.4NaNNaN20.628.9No0.0No37.6429.600000817.3209940.056883WNW56.0WW19.024.0NaNNaNNaNNaNNaNNaN
62008-01-07 00:12:00Albury14.325.00.0NaNNaN49.019.01009.61008.21.0NaN18.124.6No0.0No32.0024.800000819.7912710.030004W50.0SWW20.024.0NaNNaNNaNNaNNaNNaN
72008-01-08 00:12:00Albury7.726.70.0NaNNaN48.019.01013.41010.1NaNNaN16.325.5No0.0No34.0424.80000077.2070850.023000W35.0SSEW6.017.0NaNNaNNaNNaNNaNNaN
82008-01-09 00:12:00Albury9.731.90.0NaNNaN42.09.01008.91003.6NaNNaN18.330.2No1.4Yes40.2812.800000191.5407020.414649NNW80.0SENW7.028.0NaNNaNNaNNaNNaNNaN
92008-01-10 00:12:00Albury13.130.11.4NaNNaN58.027.01007.01005.7NaNNaN20.128.2Yes0.0No38.1234.40000078.2598330.064945W28.0SSSE15.011.0NaNNaNNaNNaNNaNNaN

Last rows

datelocationmintempmaxtemprainfallevaporationsunshinehumidity9amhumidity3pmpressure9ampressure3pmcloud9amcloud3pmtemp9amtemp3pmraintodayamountOfRainraintomorrowtemphumidityprecipitation3pmprecipitation9ammodelo_vigentewind_gustdirwind_gustspeedwind_dir9amwind_dir3pmwind_speed9amwind_speed3pmwindgustdirwindgustspeedwinddir9amwinddir3pmwindspeed9amwindspeed3pm
1643762017-01-20 00:06:00Uluru3.521.80.0NaNNaN59.027.01024.71021.2NaNNaN9.420.9No0.0No28.1634.4125.8486810.002556NaNNaNNaNNaNNaNNaNE31.0ESEE15.013.0
1643772017-01-20 00:06:00Uluru3.521.80.0NaNNaN59.027.01024.71021.2NaNNaN9.420.9No0.0No28.1634.4125.8486810.002556NaNNaNNaNNaNNaNNaNE31.0ESEE15.013.0
1643782017-01-21 00:06:00Uluru2.823.40.0NaNNaN51.024.01024.61020.3NaNNaN10.122.4No0.0No30.0830.8106.6538790.002053NaNNaNNaNNaNNaNNaNE31.0SEENE13.011.0
1643792017-01-21 00:06:00Uluru2.823.40.0NaNNaN51.024.01024.61020.3NaNNaN10.122.4No0.0No30.0830.8106.6538790.002053NaNNaNNaNNaNNaNNaNE31.0SEENE13.011.0
1643802017-01-22 00:06:00Uluru3.625.30.0NaNNaN56.021.01023.51019.1NaNNaN10.924.5No0.0No32.3627.2919.7159760.023350NaNNaNNaNNaNNaNNaNNNW22.0SEN13.09.0
1643812017-01-22 00:06:00Uluru3.625.30.0NaNNaN56.021.01023.51019.1NaNNaN10.924.5No0.0No32.3627.2919.7159760.023350NaNNaNNaNNaNNaNNaNNNW22.0SEN13.09.0
1643822017-01-23 00:06:00Uluru5.426.90.0NaNNaN53.024.01021.01016.8NaNNaN12.526.1No0.0No34.2830.8120.9855510.007195NaNNaNNaNNaNNaNNaNN37.0SEWNW9.09.0
1643832017-01-23 00:06:00Uluru5.426.90.0NaNNaN53.024.01021.01016.8NaNNaN12.526.1No0.0No34.2830.8120.9855510.007195NaNNaNNaNNaNNaNNaNN37.0SEWNW9.09.0
1643842017-01-24 00:06:00Uluru7.827.00.0NaNNaN51.024.01019.41016.53.02.015.126.0No0.0No34.4030.8154.3814810.018811NaNNaNNaNNaNNaNNaNSE28.0SSEN13.07.0
1643852017-01-24 00:06:00Uluru7.827.00.0NaNNaN51.024.01019.41016.53.02.015.126.0No0.0No34.4030.8154.3814810.018811NaNNaNNaNNaNNaNNaNSE28.0SSEN13.07.0